package com.ruoyi.vocationalcollege.mapper;

import com.ruoyi.vocationalcollege.domain.ExamVocationalCollege;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ExamVocationalCollegeMapper {

    @Select("SELECT * FROM tb_vocational_college WHERE id = #{id}")
    ExamVocationalCollege selectVocationalCollegeById(Long id);

    @Select("SELECT * FROM tb_vocational_college")
    List<ExamVocationalCollege> selectVocationalCollegeList();

    @Insert("INSERT INTO tb_vocational_college (name) VALUES (#{name})")
    int insertVocationalCollege(ExamVocationalCollege vocationalCollege);

    @Update("UPDATE tb_vocational_college SET name = #{name} WHERE id = #{id}")
    int updateVocationalCollege(ExamVocationalCollege vocationalCollege);

    @Delete("DELETE FROM tb_vocational_college WHERE id = #{id}")
    int deleteVocationalCollegeById(Long id);
}
